<!DOCTYPE html>


<html lang="en">
  

    <head>
      <meta charset="utf-8" />
        
      <meta
        name="viewport"
        content="width=device-width, initial-scale=1, maximum-scale=1"
      />
      <title>GBase8s如何配置审计功能 |  朝花夕拾</title>
  <meta name="generator" content="hexo-theme-ayer">
      
      <link rel="shortcut icon" href="/ww.ico" />
       
<link rel="stylesheet" href="/dist/main.css">

      
<link rel="stylesheet" href="/css/fonts/remixicon.css">

      
<link rel="stylesheet" href="/css/custom.css">
 
      <script src="https://cdn.staticfile.org/pace/1.2.4/pace.min.js"></script>
       
 

      <link
        rel="stylesheet"
        href="https://cdn.jsdelivr.net/npm/@sweetalert2/theme-bulma@5.0.1/bulma.min.css"
      />
      <script src="https://cdn.jsdelivr.net/npm/sweetalert2@11.0.19/dist/sweetalert2.min.js"></script>

      <!-- mermaid -->
      
      <style>
        .swal2-styled.swal2-confirm {
          font-size: 1.6rem;
        }
      </style>
    </head>
  </html>
</html>


<body>
  <div id="app">
    
      
    <main class="content on">
      <section class="outer">
  <article
  id="post-GBase8s如何配置审计功能"
  class="article article-type-post"
  itemscope
  itemprop="blogPost"
  data-scroll-reveal
>
  <div class="article-inner">
    
    <header class="article-header">
       
<h1 class="article-title sea-center" style="border-left:0" itemprop="name">
  GBase8s如何配置审计功能
</h1>
 

      
    </header>
     
    <div class="article-meta">
      <a href="/2023/05/10/GBase8s%E5%A6%82%E4%BD%95%E9%85%8D%E7%BD%AE%E5%AE%A1%E8%AE%A1%E5%8A%9F%E8%83%BD/" class="article-date">
  <time datetime="2023-05-10T01:16:17.000Z" itemprop="datePublished">2023-05-10</time>
</a> 
  <div class="article-category">
    <a class="article-category-link" href="/categories/GBase8s/">GBase8s</a>
  </div>
  
<div class="word_count">
    <span class="post-time">
        <span class="post-meta-item-icon">
            <i class="ri-quill-pen-line"></i>
            <span class="post-meta-item-text"> Word count:</span>
            <span class="post-count">2.5k</span>
        </span>
    </span>

    <span class="post-time">
        &nbsp; | &nbsp;
        <span class="post-meta-item-icon">
            <i class="ri-book-open-line"></i>
            <span class="post-meta-item-text"> Reading time≈</span>
            <span class="post-count">14 min</span>
        </span>
    </span>
</div>
 
    </div>
      
    <div class="tocbot"></div>




  
    <div class="article-entry" itemprop="articleBody">
       
  <h1 id="关于GBase8s如何配置审计功能"><a href="#关于GBase8s如何配置审计功能" class="headerlink" title="关于GBase8s如何配置审计功能"></a>关于GBase8s如何配置审计功能</h1><h2 id="1、配置审计："><a href="#1、配置审计：" class="headerlink" title="1、配置审计："></a>1、配置审计：</h2><p>a、通过gbasedbt用户登录操作系统，执行</p>
<figure class="highlight sql"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">mkdir <span class="operator">~</span><span class="operator">/</span>audit_log</span><br></pre></td></tr></table></figure>

<p>b、指定审计文件路径为&#x2F;opt&#x2F;gbase8s&#x2F;audit_log，大小256MB</p>
<figure class="highlight sql"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">onaudit <span class="operator">-</span>p <span class="operator">~</span><span class="operator">/</span>audit_log <span class="operator">-</span>s <span class="number">256000000</span></span><br></pre></td></tr></table></figure>

<p>c、指定用户缺省下需要审计的事件（访问数据表，更新数据行，删除数据行，插入数据行）</p>
<figure class="highlight sql"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">onaudit <span class="operator">-</span>a <span class="operator">-</span>u _default <span class="operator">-</span>e <span class="operator">+</span>ACTB,UPRW,DLRW,INRW</span><br></pre></td></tr></table></figure>

<p>查看审计事件：</p>
<figure class="highlight sql"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">onaudit <span class="operator">-</span>o <span class="operator">-</span>u _default</span><br></pre></td></tr></table></figure>

<p>修改掩码（+表示添加，-表示删除）</p>
<figure class="highlight sql"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">onaudit <span class="operator">-</span>m <span class="operator">-</span>u _default <span class="operator">-</span>e <span class="operator">+</span>DLRW,INRW,CRTB, <span class="operator">-</span>e <span class="operator">-</span>ACTB</span><br></pre></td></tr></table></figure>

<p>删除审计事件</p>
<figure class="highlight sql"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">onaudit <span class="operator">-</span>d <span class="operator">-</span>u _default</span><br></pre></td></tr></table></figure>

<p>d、打开按行审计模式(细粒度审计)</p>
<figure class="highlight sql"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">onaudit <span class="operator">-</span>R <span class="number">0</span></span><br></pre></td></tr></table></figure>

<h2 id="2、启用审计："><a href="#2、启用审计：" class="headerlink" title="2、启用审计："></a>2、启用审计：</h2><figure class="highlight sql"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">onaudit <span class="operator">-</span>l <span class="number">1</span></span><br></pre></td></tr></table></figure>

<h2 id="3、启用审计后输出至日志："><a href="#3、启用审计后输出至日志：" class="headerlink" title="3、启用审计后输出至日志："></a>3、启用审计后输出至日志：</h2><p>a、通过gbasedbt用户登录操作系统并连接数据库实例，执行</p>
<figure class="highlight sql"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">dbaccess <span class="operator">-</span> <span class="operator">-</span></span><br></pre></td></tr></table></figure>

<p>b、执行数据库操作，在数据库操作符下执行：</p>
<figure class="highlight sql"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br><span class="line">3</span><br><span class="line">4</span><br><span class="line">5</span><br><span class="line">6</span><br><span class="line">7</span><br><span class="line">8</span><br><span class="line">9</span><br></pre></td><td class="code"><pre><span class="line"><span class="keyword">create</span> database testaudit;</span><br><span class="line">database testaudit;</span><br><span class="line"><span class="keyword">create</span> <span class="keyword">table</span> testtable(id <span class="type">int</span>,subject <span class="type">varchar</span>(<span class="number">20</span>));</span><br><span class="line"><span class="keyword">insert</span> <span class="keyword">into</span> testtable  <span class="keyword">values</span> (<span class="number">1</span>,<span class="string">&#x27;insert data&#x27;</span>);                     </span><br><span class="line"><span class="keyword">update</span> testtable <span class="keyword">set</span> subject<span class="operator">=</span><span class="string">&#x27;update data&#x27;</span> <span class="keyword">where</span> id<span class="operator">=</span><span class="number">1</span>;</span><br><span class="line"><span class="keyword">select</span> <span class="operator">*</span> <span class="keyword">from</span> testtable;</span><br><span class="line"><span class="keyword">delete</span> <span class="keyword">from</span> testtable;</span><br><span class="line">database sysadmin;</span><br><span class="line"><span class="keyword">drop</span> database testaudit;</span><br></pre></td></tr></table></figure>

<p>c、浏览审计日志，在系统提示符下执行：</p>
<figure class="highlight sql"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">onshowaudit <span class="operator">-</span>f <span class="operator">~</span><span class="operator">/</span>audit_log<span class="operator">/</span>ol_gbase8s<span class="number">.0</span> </span><br></pre></td></tr></table></figure>

<h2 id="4、关闭审计"><a href="#4、关闭审计" class="headerlink" title="4、关闭审计"></a>4、关闭审计</h2><figure class="highlight sql"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">onaudit <span class="operator">-</span>l <span class="number">0</span></span><br></pre></td></tr></table></figure>

<h2 id="5、关闭审计后审计日志输出"><a href="#5、关闭审计后审计日志输出" class="headerlink" title="5、关闭审计后审计日志输出"></a>5、关闭审计后审计日志输出</h2><p>a、通过gbasedbt用户登录操作系统并连接数据库实例，执行</p>
<figure class="highlight sql"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">dbaccess <span class="operator">-</span> <span class="operator">-</span></span><br></pre></td></tr></table></figure>

<p>b、执行数据库操作，在数据库操作符下执行：</p>
<figure class="highlight sql"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br><span class="line">3</span><br><span class="line">4</span><br><span class="line">5</span><br><span class="line">6</span><br><span class="line">7</span><br><span class="line">8</span><br><span class="line">9</span><br></pre></td><td class="code"><pre><span class="line"><span class="keyword">create</span> database testaudit;</span><br><span class="line">database testaudit;</span><br><span class="line"><span class="keyword">create</span> <span class="keyword">table</span> testtable(id <span class="type">int</span>,subject <span class="type">varchar</span>(<span class="number">20</span>));</span><br><span class="line"><span class="keyword">insert</span> <span class="keyword">into</span> testtable <span class="keyword">values</span> (<span class="number">1</span>,<span class="string">&#x27;insert data&#x27;</span>);                     </span><br><span class="line"><span class="keyword">update</span> testtable <span class="keyword">set</span> subject<span class="operator">=</span><span class="string">&#x27;update data&#x27;</span> <span class="keyword">where</span> id<span class="operator">=</span><span class="number">1</span>;</span><br><span class="line"><span class="keyword">select</span> <span class="operator">*</span> <span class="keyword">from</span> testtable;</span><br><span class="line"><span class="keyword">delete</span> <span class="keyword">from</span> testtable;</span><br><span class="line">database sysadmin;</span><br><span class="line"><span class="keyword">drop</span> database testaudit;</span><br></pre></td></tr></table></figure>

<p>c、浏览审计日志，在系统提示符下执行：</p>
<figure class="highlight sql"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">onshowaudit <span class="operator">-</span>f <span class="operator">/</span>opt<span class="operator">/</span>gbase8s<span class="operator">/</span>audit_log<span class="operator">/</span>ol_gbase8s<span class="number">.0</span></span><br></pre></td></tr></table></figure>







<hr>
<h1 id="知识扩展"><a href="#知识扩展" class="headerlink" title="知识扩展"></a>知识扩展</h1><h2 id="检查审计配置"><a href="#检查审计配置" class="headerlink" title="检查审计配置"></a>检查审计配置</h2><figure class="highlight shell"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br><span class="line">3</span><br><span class="line">4</span><br><span class="line">5</span><br><span class="line">6</span><br><span class="line">7</span><br><span class="line">8</span><br><span class="line">9</span><br><span class="line">10</span><br><span class="line">11</span><br></pre></td><td class="code"><pre><span class="line">gbasedbt@wei66:~$ onaudit -c</span><br><span class="line">Onaudit -- Audit Subsystem Configuration Utility</span><br><span class="line"></span><br><span class="line">Current audit system configuration:</span><br><span class="line">    ADTMODE    = 0</span><br><span class="line">    ADTERR     = 0</span><br><span class="line">    ADTPATH    = /home/gbasedbt/audit_log</span><br><span class="line">    ADTSIZE    = 256000000</span><br><span class="line">    Audit file = 0</span><br><span class="line">    ADTROWS    = 0</span><br><span class="line">gbasedbt@wei66:~$ </span><br></pre></td></tr></table></figure>

<h3 id="ADTMODE-审计级别"><a href="#ADTMODE-审计级别" class="headerlink" title="ADTMODE 审计级别"></a>ADTMODE 审计级别</h3><p>onaudit -l 1</p>
<figure class="highlight shell"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br><span class="line">3</span><br><span class="line">4</span><br><span class="line">5</span><br><span class="line">6</span><br></pre></td><td class="code"><pre><span class="line">要开始审计所有会话，需输入 $ onaudit -l 1。以下是附加审计级别选项：</span><br><span class="line">0 = 禁用审计</span><br><span class="line">1 = 启用审计，审计所有会话</span><br><span class="line">3 = 启用审计，审计 DBSSO 操作</span><br><span class="line">5 = 启用审计，审计数据库服务器管理员操作</span><br><span class="line">7 = 启用审计，审计 DBSSO 及数据库服务器管理员操作</span><br></pre></td></tr></table></figure>

<h3 id="ADTERR"><a href="#ADTERR" class="headerlink" title="ADTERR"></a>ADTERR</h3><p>onaudit -e 0 </p>
<figure class="highlight shell"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br><span class="line">3</span><br></pre></td><td class="code"><pre><span class="line">0 =继续错误模式</span><br><span class="line">1 = halt错误模式:暂停线程处理</span><br><span class="line">3 = halt error mode:关闭系统</span><br></pre></td></tr></table></figure>

<h3 id="ADTPATH"><a href="#ADTPATH" class="headerlink" title="ADTPATH"></a>ADTPATH</h3><p>审计日志存储路径。通过 -p可以设置。</p>
<h3 id="ADTSIZE"><a href="#ADTSIZE" class="headerlink" title="ADTSIZE"></a>ADTSIZE</h3><p>单个审计文件的大小，单位是字节。通过 -s可以设置。</p>
<h3 id="Audit-file"><a href="#Audit-file" class="headerlink" title="Audit file"></a>Audit file</h3><p>是审计文件的下标，用onaudit -n 切换一个，这个Audit fIle 就会加1.</p>
<h3 id="ADTROWS"><a href="#ADTROWS" class="headerlink" title="ADTROWS"></a>ADTROWS</h3><p>onaudit -R 1 </p>
<figure class="highlight shell"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br><span class="line">3</span><br><span class="line">4</span><br><span class="line">5</span><br><span class="line">6</span><br><span class="line">7</span><br><span class="line">8</span><br><span class="line">9</span><br></pre></td><td class="code"><pre><span class="line">行审计 Options: </span><br><span class="line">0 = Auditing row-level events on all tables (0 is the default value) </span><br><span class="line">1 = Selective row-level auditing is enabled for tables set with the AUDIT flag. </span><br><span class="line">2 = Selective row-level auditing is enabled for tables set with the AUDIT flag.</span><br><span class="line"></span><br><span class="line">翻译：</span><br><span class="line">0 =审计所有表上的行级事件(0是默认值)</span><br><span class="line">1 =对带有AUDIT标志的表启用选择性行级审计。</span><br><span class="line">2 =对带有AUDIT标志的表启用选择性行级审计。</span><br></pre></td></tr></table></figure>



<h1 id="查看审计文件"><a href="#查看审计文件" class="headerlink" title="查看审计文件"></a>查看审计文件</h1><p>审计文件后面的三个字段，分别是 tid，partnum，rowid</p>
<figure class="highlight shell"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br><span class="line">3</span><br><span class="line">4</span><br><span class="line">5</span><br><span class="line">6</span><br><span class="line">7</span><br><span class="line">8</span><br><span class="line">9</span><br><span class="line">10</span><br><span class="line">11</span><br><span class="line">12</span><br><span class="line">13</span><br><span class="line">14</span><br><span class="line">15</span><br><span class="line">16</span><br><span class="line">17</span><br><span class="line">18</span><br><span class="line">19</span><br><span class="line">20</span><br><span class="line">21</span><br><span class="line">22</span><br><span class="line">23</span><br><span class="line">24</span><br></pre></td><td class="code"><pre><span class="line">gbasedbt@wei66:~/audit_log$ tail g300.3 </span><br><span class="line">ONLN|2022-12-11 16:41:02.000|localhost|24531|g300|gbasedbt|0:UPRW:sysmaster:226:1025:0:1025:256::</span><br><span class="line">ONLN|2022-12-11 16:41:02.000|localhost|24531|g300|gbasedbt|0:ACTB:sysmaster:gbasedbt:syscrtadt:227</span><br><span class="line">ONLN|2022-12-11 16:41:02.000|localhost|24531|g300|gbasedbt|0:INRW:sysmaster:227:1026:11010::</span><br><span class="line">ONLN|2022-12-11 16:41:19.000|localhost|24536|g300|gbasedbt|0:ACTB:sysmaster:gbasedbt:sysadtinfo:226</span><br><span class="line">ONLN|2022-12-11 16:41:19.000|localhost|24536|g300|gbasedbt|0:ACTB:sysmaster:gbasedbt:sysadtinfo:226</span><br><span class="line">ONLN|2022-12-11 16:41:19.000|localhost|24536|g300|gbasedbt|0:ACTB:sysmaster:gbasedbt:syscrtadt:227</span><br><span class="line">ONLN|2022-12-11 16:41:19.000|localhost|24536|g300|gbasedbt|0:INRW:sysmaster:227:1026:11010::</span><br><span class="line">ONLN|2022-12-11 16:42:45.000|localhost|24537|g300|gbasedbt|0:ACTB:sysmaster:gbasedbt:sysadtinfo:226</span><br><span class="line">ONLN|2022-12-11 16:42:45.000|localhost|24537|g300|gbasedbt|0:ACTB:sysmaster:gbasedbt:sysadtinfo:226</span><br><span class="line">gbasedbt@wei66:~/audit_log$ </span><br><span class="line">gbasedbt@wei66:~/audit_log$ </span><br><span class="line">gbasedbt@wei66:~/audit_log$ tail g300.10</span><br><span class="line">ONLN|2022-12-11 16:49:10.000|localhost|24617|g300|gbasedbt|0:DLRW:testdb:114:9437261:2081556::</span><br><span class="line">ONLN|2022-12-11 16:49:10.000|localhost|24617|g300|gbasedbt|0:DLRW:testdb:114:9437261:2081793::</span><br><span class="line">ONLN|2022-12-11 16:49:10.000|localhost|24617|g300|gbasedbt|0:DLRW:testdb:114:9437261:2081794::</span><br><span class="line">ONLN|2022-12-11 16:49:10.000|localhost|24617|g300|gbasedbt|0:DLRW:testdb:114:9437261:2081795::</span><br><span class="line">ONLN|2022-12-11 16:49:10.000|localhost|24617|g300|gbasedbt|0:DLRW:testdb:114:9437261:2081796::</span><br><span class="line">ONLN|2022-12-11 16:49:10.000|localhost|24617|g300|gbasedbt|0:DLRW:testdb:114:9437261:2081797::</span><br><span class="line">ONLN|2022-12-11 16:49:10.000|localhost|24617|g300|gbasedbt|0:DLRW:testdb:114:9437261:2081798::</span><br><span class="line">ONLN|2022-12-11 16:49:10.000|localhost|24617|g300|gbasedbt|0:DLRW:testdb:114:9437261:2081799::</span><br><span class="line">ONLN|2022-12-11 16:49:10.000|localhost|24617|g300|gbasedbt|0:DLRW:testdb:114:9437261:2081800::</span><br><span class="line">ONLN|2022-12-11 16:49:10.000|localhost|24617|g300|gbasedbt|0:DLRW:testdb:114:9437261:2081801::</span><br><span class="line">gbasedbt@wei66:~/audit_log$ </span><br></pre></td></tr></table></figure>





<h1 id="审计掩码"><a href="#审计掩码" class="headerlink" title="审计掩码"></a>审计掩码</h1><p><a target="_blank" rel="noopener" href="https://www.ibm.com/docs/en/informix-servers/12.10?topic=analysis-audit-record-format">https://www.ibm.com/docs/en/informix-servers/12.10?topic=analysis-audit-record-format</a></p>
<p><a target="_blank" rel="noopener" href="https://www.ibm.com/docs/en/informix-servers/12.10?topic=security-audit-event-codes-fields#ids_au_104">https://www.ibm.com/docs/en/informix-servers/12.10?topic=security-audit-event-codes-fields#ids_au_104</a></p>
<table>
<thead>
<tr>
<th>Event Code</th>
<th>Event</th>
<th>Variable Contents</th>
</tr>
</thead>
<tbody><tr>
<td>ACTB</td>
<td>Access Table</td>
<td>dbname: database_nametabid: owner_name, table_id</td>
</tr>
<tr>
<td>ADCK</td>
<td>Add Chunk</td>
<td>dbname: dbspace, nameextra_1: offset flags: mirror_status1 extra_2: path and size</td>
</tr>
<tr>
<td>ADLG</td>
<td>Add Transaction Log</td>
<td>dbname: dbspace, nameextra_1: log_size</td>
</tr>
<tr>
<td>ALFR</td>
<td>Alter Fragement</td>
<td>dbname: database_nametabid: table_id objname: index_name extra_1: operation_type18 login: owner flags: frag_flags15 extra_2: dbspaces alter_type: 0 &#x3D; normal, 1 &#x3D; forced alter</td>
</tr>
<tr>
<td>ALIX</td>
<td>Alter Index</td>
<td>dbname: database_nametabid: table_id login: owner14 flags: cluster_flag9,14 extra_2: index_name14</td>
</tr>
<tr>
<td>ALLC</td>
<td>Alter Security Label Component</td>
<td>dbname: database_nameobjname: component_name extra_2: component_type</td>
</tr>
<tr>
<td>ALME</td>
<td>Alter Access Method</td>
<td>dbname: database_nametabid: access, method_ID objname: access_method, name login: access_method, owner</td>
</tr>
<tr>
<td>ALOC</td>
<td>Alter Operator Class</td>
<td>dbname: database_nameextra_1: cluster_size login: owner extra_2: cluster_name</td>
</tr>
<tr>
<td>ALSQ</td>
<td>Alter Sequence</td>
<td>dbname: database_nametabid: table_id</td>
</tr>
<tr>
<td>ALTB</td>
<td>Alter Table</td>
<td>dbname: database_nametabid: old_table_id extra_1: new_table_id14 partno: frag_id extra_2: new_part_number_list14</td>
</tr>
<tr>
<td>ALTX</td>
<td>Alter trusted context</td>
<td>dbname: database_nameobjname: context_name login: system_authid</td>
</tr>
<tr>
<td>ALUR</td>
<td>Alter User</td>
<td>objname: user_name</td>
</tr>
<tr>
<td>BGTX</td>
<td>Begin Transaction</td>
<td>none</td>
</tr>
<tr>
<td>CLDB</td>
<td>Close Database</td>
<td>dbname: database_name</td>
</tr>
<tr>
<td>CMTX</td>
<td>Commit Transaction</td>
<td>none</td>
</tr>
<tr>
<td>CRAG</td>
<td>Create Aggregate</td>
<td>dbname: database_nameobjname: aggregate_name login: owner</td>
</tr>
<tr>
<td>CRAM</td>
<td>Create Audit Mask</td>
<td>login: user_id</td>
</tr>
<tr>
<td>CRBS</td>
<td>Create Storage Space</td>
<td>dbname: storage_name, space_namelogin: owner flags: mirror_status1 extra_2: media</td>
</tr>
<tr>
<td>CRBT</td>
<td>Create Opaque Type</td>
<td>dbname: database_nameobjname: opaque_type_name login: opaque_type, owner</td>
</tr>
<tr>
<td>CRCT</td>
<td>Create Cast</td>
<td>dbname: database_nametabid: from_type_ID objname: function_name or “-“ extra_1: from_type_xid partno: to_type_ID row_num: to_type_xid login: function_owner or “-“</td>
</tr>
<tr>
<td>CRDB</td>
<td>Create Database</td>
<td>dbname: dbspaceextra_2: database_name</td>
</tr>
<tr>
<td>CRDS</td>
<td>Create Dbspace</td>
<td>dbname: dbspace, nameflags: mirror_status1</td>
</tr>
<tr>
<td>CRDT</td>
<td>Create Distinct Type</td>
<td>dbname: database_nameobjname: distinct_type_name login: distinct_type, owner</td>
</tr>
<tr>
<td>CRIX</td>
<td>Create Index</td>
<td>dbname: database_nametabid: table_id objname: index_name login: owner flags: frag_flags15 extra_2: dbspace_list</td>
</tr>
<tr>
<td>CRLB</td>
<td>Create Security Label</td>
<td>dbname: database_nameobjname: policy.label_name</td>
</tr>
<tr>
<td>CRLC</td>
<td>Create Security Label Component</td>
<td>dbname: database_nameobjname: component_name</td>
</tr>
<tr>
<td>CRME</td>
<td>Create Access Method</td>
<td>dbname: database_nametabid: access_method_ID objname: access_method_name login: access_method_owner</td>
</tr>
<tr>
<td>CROC</td>
<td>Create Operator Class</td>
<td>dbname: database_nametabid: operator_class_ID objname: operator_class_name login: owner</td>
</tr>
<tr>
<td>CRPL</td>
<td>Create Security Policy</td>
<td>dbname: database_nameobjname: policy_name</td>
</tr>
<tr>
<td>CRPT</td>
<td>Decryption Failure or Attempt</td>
<td>dbname: database_nameobjname: statement</td>
</tr>
<tr>
<td>CRRL</td>
<td>Create Role</td>
<td>dbname: database_nameobjname: rolename</td>
</tr>
<tr>
<td>CRRT</td>
<td>Create Named Row Type</td>
<td>dbname: database_nametabid: row_type_xid objname: named_row_type_name login: named_row_type_owner</td>
</tr>
<tr>
<td>CRSN</td>
<td>Create Synonym</td>
<td>dbname: database_nametabid: synonym_table_id extra_1: base_table_id login: owner flags: synonym_type7 extra_2: synonym_name</td>
</tr>
<tr>
<td>CRSP</td>
<td>Create SPL Routine</td>
<td>dbname: database_nametabid: proc_id login: owner extra_2: procedure_name</td>
</tr>
<tr>
<td>CRSQ</td>
<td>Create Sequence</td>
<td>dbname: database_nametabid: table_id objname: owner</td>
</tr>
<tr>
<td>CRTB</td>
<td>Create Table</td>
<td>dbname: database_nametabid: table_id objname: owner login: table_name flags: frag_flags15 extra_2: dbspace_list</td>
</tr>
<tr>
<td>CRTR</td>
<td>Create Trigger</td>
<td>dbname: database_nametabid: table_id row_num: trigger_id14 login: owner14 extra_2: trigger_name14</td>
</tr>
<tr>
<td>CRTX</td>
<td>Create trusted context</td>
<td>dbname: database_nameobjname: context_name login: system_authorization_id</td>
</tr>
<tr>
<td>CRUR</td>
<td>Create User</td>
<td>objname: user_name</td>
</tr>
<tr>
<td>CRVW</td>
<td>Create View</td>
<td>dbname: database_nametabid: view_table_id login: owner extra_2: view_name</td>
</tr>
<tr>
<td>CRXD</td>
<td>Create XADatasource</td>
<td>dbname: database_nameobjname: owner objname: XA_data_source_name</td>
</tr>
<tr>
<td>CRXT</td>
<td>Create XADatasource Type</td>
<td>dbname: database_nameobjname: owner objname: XA_data_source_type_name</td>
</tr>
<tr>
<td>DLRW</td>
<td>Delete Row</td>
<td>dbname: database_nametabid: table_id extra_1: part_number partno: frag_id row_num: row_number14</td>
</tr>
<tr>
<td>DNCK</td>
<td>Bring Chunk Offline</td>
<td>extra_1: chunk_numberflags: mirror_status1</td>
</tr>
<tr>
<td>DNDM</td>
<td>Disable Disk Mirroring</td>
<td>extra_1: dbspace_number</td>
</tr>
<tr>
<td>DRAG</td>
<td>Drop Aggregate</td>
<td>dbname: database_nameobjname: aggregate_name login: owner</td>
</tr>
<tr>
<td>DRAM</td>
<td>Delete Audit Mask</td>
<td>login: user_id</td>
</tr>
<tr>
<td>DRBS</td>
<td>Drop Storage Space</td>
<td>dbname: storage_space_name</td>
</tr>
<tr>
<td>DRCK</td>
<td>Drop Chunk</td>
<td>dbname: dbspace_nameflags: mirror_status1 extra_2: path</td>
</tr>
<tr>
<td>DRCT</td>
<td>Drop Cast</td>
<td>dbname: database_nametabid: from_type_ID extra_1: from_type_xid partno: to_type_ID row_num: to_type_xid</td>
</tr>
<tr>
<td>DRDB</td>
<td>Drop Database</td>
<td>dbname: database_name</td>
</tr>
<tr>
<td>DRDS</td>
<td>Drop Dbspace</td>
<td>dbname: dbspace_name</td>
</tr>
<tr>
<td>DRIX</td>
<td>Drop Index</td>
<td>dbname: database_nametabid: table_id login: owner extra_2: index_name</td>
</tr>
<tr>
<td>DRLB</td>
<td>Drop Security Label</td>
<td>dbname: database_nameobjname: policy.label_name</td>
</tr>
<tr>
<td>DRLC</td>
<td>Drop Security Label Component</td>
<td>dbname: database_nameobjname: component_name</td>
</tr>
<tr>
<td>DRLG</td>
<td>Drop Transaction Log</td>
<td>extra_1: log_number</td>
</tr>
<tr>
<td>DRME</td>
<td>Drop Access Method</td>
<td>dbname: database_nametabid: access_method_ID objname: access_method_name login: access_method_owner</td>
</tr>
<tr>
<td>DROC</td>
<td>Drop Operator Class</td>
<td>dbname: database_nameobjname: operator_class_name login: owner</td>
</tr>
<tr>
<td>DRPL</td>
<td>Drop Security Policy</td>
<td>dbname: database_nameobjname: policy_name</td>
</tr>
<tr>
<td>DRRL</td>
<td>Drop Role</td>
<td>dbname: database_nameobjname: role_name</td>
</tr>
<tr>
<td>DRRT</td>
<td>Drop Named Row Type</td>
<td>dbname: database_nametabid: dropped_type_xid</td>
</tr>
<tr>
<td>DRSN</td>
<td>Drop Synonym</td>
<td>dbname: database_nametabid: synonym_table_id login: owner extra_2: synonym_name</td>
</tr>
<tr>
<td>DRSP</td>
<td>Drop SPL Routine</td>
<td>dbname: database_namelogin: owner extra_2: spname</td>
</tr>
<tr>
<td>DRSQ</td>
<td>Drop Sequence</td>
<td>dbname: database_nametabid: table_id</td>
</tr>
<tr>
<td>DRTB</td>
<td>Drop Table</td>
<td>dbname: database_nametabid: table_id objname: table_name login: owner flags: drop_flags21 extra_2: part_number_list</td>
</tr>
<tr>
<td>DRTR</td>
<td>Drop Trigger</td>
<td>dbname: database_namerow_num: trigger_id login: owner extra_2: trigger_name</td>
</tr>
<tr>
<td>DRUR</td>
<td>Drop User</td>
<td>objname: user_name</td>
</tr>
<tr>
<td>DRTX</td>
<td>Drop trusted context</td>
<td>objname: context_name</td>
</tr>
<tr>
<td>DRTY</td>
<td>Drop Type</td>
<td>dbname: database_nameobjname: type_name login: type_owner</td>
</tr>
<tr>
<td>DRVW</td>
<td>Drop View</td>
<td>dbname: database_nametabid: view_table_id flags: drop_flags21</td>
</tr>
<tr>
<td>DRXD</td>
<td>Drop XADatasource</td>
<td>dbname: database_nameobjname: owner objname: XA_data_source_name</td>
</tr>
<tr>
<td>DRXT</td>
<td>Drop XADatasource Type</td>
<td>dbname: database_nameobjname: owner objname: XA_data_source_type_name</td>
</tr>
<tr>
<td>EXSP</td>
<td>Execute SPL Routine</td>
<td>dbname: database_nametabid: proc_id</td>
</tr>
<tr>
<td>GRDB</td>
<td>Grant Database Access</td>
<td>dbname: database_nameextra_1: privilege5 extra_2: grantees4</td>
</tr>
<tr>
<td>GRDR</td>
<td>Grant Default Role</td>
<td>dbname: database_nameobjname: role_name login:grantor extra_2: grantees4</td>
</tr>
<tr>
<td>GRFR</td>
<td>Grant Fragment Access</td>
<td>dbname: database_nametabid: table_id objname: fragment extra_1: privilege5, 14 login: grantor extra_2: grantees4, 14</td>
</tr>
<tr>
<td>GRLB</td>
<td>Grant Security Label</td>
<td>dbname: database_nameobjname: policy.label_name login: grantee4 extra_2: access_type</td>
</tr>
<tr>
<td>GRRL</td>
<td>Grant Role</td>
<td>dbname: database_nameobjname: role_name login: grantor extra_2: grantees4</td>
</tr>
<tr>
<td>GRSA</td>
<td>Grant DBSECADM</td>
<td>login: grantee</td>
</tr>
<tr>
<td>GRSS</td>
<td>Grant SETSESSIONAUTH</td>
<td>dbname: database_namelogin: grantee extra_2: surrogate_user_list</td>
</tr>
<tr>
<td>GRTB</td>
<td>Grant Table Access</td>
<td>dbname: database_nametabid: table_id extra_1: privilege5, 14 login: grantor extra_2: grantee4, 14, update_columns, select_columns4, 14</td>
</tr>
<tr>
<td>GRXM</td>
<td>Grant Exemption</td>
<td>dbname: database_nameobjname: policy_name login: grantee extra_2: rule</td>
</tr>
<tr>
<td>INRW</td>
<td>Insert Row</td>
<td>dbname: database_nametabid: table_id partno: frag_id row_num: row_id</td>
</tr>
<tr>
<td>LGDB</td>
<td>Change Database Log Mode</td>
<td>dbname: database_nameflags: log_status6</td>
</tr>
<tr>
<td>LKTB</td>
<td>Lock Table</td>
<td>dbname: database_nametabid: table_id flags: lock_mode8</td>
</tr>
<tr>
<td>LSAM</td>
<td>List Audit Masks</td>
<td>none</td>
</tr>
<tr>
<td>LSDB</td>
<td>List Databases</td>
<td>none</td>
</tr>
<tr>
<td>MDLG</td>
<td>Modify Transaction Logging</td>
<td>flags: buffered_log_flags2</td>
</tr>
<tr>
<td>ONAU</td>
<td>onaudit</td>
<td>extra_2: command_line</td>
</tr>
<tr>
<td>ONBR</td>
<td>onbar</td>
<td>extra_2: command_line</td>
</tr>
<tr>
<td>ONCH</td>
<td>oncheck</td>
<td>extra_2: command_line</td>
</tr>
<tr>
<td>ONIN</td>
<td>oninit</td>
<td>extra_2: command_line</td>
</tr>
<tr>
<td>ONLG</td>
<td>onlog</td>
<td>extra_2: command_line</td>
</tr>
<tr>
<td>ONLO</td>
<td>onload</td>
<td>extra_2: command_line</td>
</tr>
<tr>
<td>ONMN</td>
<td>onmonitor</td>
<td>extra_2: command_line</td>
</tr>
<tr>
<td>ONMO</td>
<td>onmode</td>
<td>extra_2: command_line</td>
</tr>
<tr>
<td>ONPA</td>
<td>onparams</td>
<td>extra_2: command_line</td>
</tr>
<tr>
<td>ONPL</td>
<td>onpload</td>
<td>extra_2: command_line</td>
</tr>
<tr>
<td>ONSP</td>
<td>onspaces</td>
<td>extra_2: command_line</td>
</tr>
<tr>
<td>ONST</td>
<td>onstat</td>
<td>extra_2: command_line</td>
</tr>
<tr>
<td>ONTP</td>
<td>ontape</td>
<td>extra_2: command_line</td>
</tr>
<tr>
<td>ONUL</td>
<td>onunload</td>
<td>extra_2: command_line</td>
</tr>
<tr>
<td>OPDB</td>
<td>Open Database</td>
<td>dbname: database_nameflags: exclusive_flag extra_2: database_password</td>
</tr>
<tr>
<td>OPST</td>
<td>Optimize Storage</td>
<td>fragment <parameters>: part_numbers table <parameters>: table_name:database_name:owner_name compression purge_dictionary: date</td>
</tr>
<tr>
<td>PWUR</td>
<td>Set User Password</td>
<td>objname: user_name</td>
</tr>
<tr>
<td>RBSV</td>
<td>Rollback to Savepoint</td>
<td>dbname: database_name extra_1: transaction_id objname: savepoint_name</td>
</tr>
<tr>
<td>RDRW</td>
<td>Read Row</td>
<td>dbname: database_nametabid: table_id extra_1: part_number partno: frag_id row_num: row_id14</td>
</tr>
<tr>
<td>RLSV</td>
<td>Release Savepoint</td>
<td>dbname: database_name extra_1: transaction_id objname: savepoint_name</td>
</tr>
<tr>
<td>RLTX</td>
<td>Rollback Transaction</td>
<td>none</td>
</tr>
<tr>
<td>RMCK</td>
<td>Clear Mirrored Chunks</td>
<td>extra_1: dbspace_number</td>
</tr>
<tr>
<td>RNUR</td>
<td>Rename User</td>
<td>objname: old_user_nameextra_2: new_user_name</td>
</tr>
<tr>
<td>RNDB</td>
<td>Rename Database</td>
<td>dbname: database_nameobjname: new_dbname login: user_id</td>
</tr>
<tr>
<td>RNDS</td>
<td>Rename dbspace</td>
<td>dbname: dbspace_nameobjname: new_dbspace_name</td>
</tr>
<tr>
<td>RNIX</td>
<td>Rename Index</td>
<td>dbname: index_nameobjname: new_index_name</td>
</tr>
<tr>
<td>RNLB</td>
<td>Rename Security Label</td>
<td>dbname: database_nameobjname: old_policy.label_name extra_2: new_policy.label_name</td>
</tr>
<tr>
<td>RNLC</td>
<td>Rename Security Label Component</td>
<td>dbname: database_nameobjname: old_component_name extra_2: new_component_name</td>
</tr>
<tr>
<td>RNPL</td>
<td>Rename Security Policy</td>
<td>dbname: database_nameobjname: old_policy_name extra_2: new_policy_name</td>
</tr>
<tr>
<td>RNSQ</td>
<td>Rename Sequence</td>
<td>dbname: database_nametabid: table_id</td>
</tr>
<tr>
<td>RNTC</td>
<td>Rename Table&#x2F;Column</td>
<td>dbname: database_nametabid: table_id objname: new_table&#x2F;column_name extra_1: colno(*) login: owner extra_2: table_name(**)</td>
</tr>
<tr>
<td>RNTX</td>
<td>Rename trusted context</td>
<td>objname: context_nameextra_2: new_context name</td>
</tr>
<tr>
<td>RVDB</td>
<td>Revoke Database Access</td>
<td>dbname: database_name extra_1: privilege5 extra_2: revokees4</td>
</tr>
<tr>
<td>RVDR</td>
<td>Revoke Default Role</td>
<td>dbname: database_nameobjname: role_name login: revoker extra_2: revokees4</td>
</tr>
<tr>
<td>RVFR</td>
<td>Revoke Fragment Access</td>
<td>dbname: database_nametabid: table_id objname: fragment extra_1: privilege5, 14 login: revoker extra_2: revokees4, 14</td>
</tr>
<tr>
<td>RVLB</td>
<td>Revoke Security Label</td>
<td>dbname: database_nameobjname: policy.label_name login: grantee extra_2: access_type</td>
</tr>
<tr>
<td>RVRL</td>
<td>Revoke Role</td>
<td>dbname: database_nameobjname: role_name login: revoker extra_2: revokees4</td>
</tr>
<tr>
<td>RVSA</td>
<td>Revoke DBSECADM</td>
<td>login: grantee</td>
</tr>
<tr>
<td>RVSS</td>
<td>Revoke SETSESSIONAUTH</td>
<td>dbname: database_namelogin: grantee extra_2: surrogate_user_list</td>
</tr>
<tr>
<td>RVTB</td>
<td>Revoke Table Access</td>
<td>dbname: database_nametabid: table_id extra_1: privilege5, 14 login: revoker flags: drop_flags21 extra_2: revokees4, 14</td>
</tr>
<tr>
<td>RVXM</td>
<td>Revoke Exemption</td>
<td>dbname: database_nameobjname: policy_name login: grantee extra_2: rule</td>
</tr>
<tr>
<td>SCSP</td>
<td>System Command, SPL Routine</td>
<td>extra_2: command_string</td>
</tr>
<tr>
<td>STCO</td>
<td>Set Collation</td>
<td>dbname: database_nameobjname: locale_name</td>
</tr>
<tr>
<td>STCN</td>
<td>Set Constraint</td>
<td>dbname: database_nameflags: constraint_mode11 extra_2: constraint_names</td>
</tr>
<tr>
<td>STDF</td>
<td>Set Debug File</td>
<td>dbname: database_nameextra_2: file_path</td>
</tr>
<tr>
<td>STDP</td>
<td>Set Database Password</td>
<td>dbname: database_namelogin: user_id</td>
</tr>
<tr>
<td>STDS</td>
<td>Set Dataskip</td>
<td>flags: skip flags16extra_2: dbspace_list</td>
</tr>
<tr>
<td>STEP</td>
<td>Set Encryption Password</td>
<td>dbname: database_name</td>
</tr>
<tr>
<td>STEV</td>
<td>Set Environment</td>
<td>objname: environment_variable_and_value</td>
</tr>
<tr>
<td>STEX</td>
<td>Set Explain</td>
<td>flags: explain_flags12</td>
</tr>
<tr>
<td>STIL</td>
<td>Set Isolation Level</td>
<td>extra_1: isolation_level3</td>
</tr>
<tr>
<td>STLM</td>
<td>Set Lock Mode</td>
<td>flags: wait_flags13</td>
</tr>
<tr>
<td>STNC</td>
<td>Set No Collation</td>
<td>dbname: database_nameobjname: locale_name</td>
</tr>
<tr>
<td>STOM</td>
<td>Set Object Mode</td>
<td>dbname: database_nametabid: table_id extra_1: command_mode_flag22 flags: object_type_flag23 extra_2: object_names</td>
</tr>
<tr>
<td>STOP</td>
<td>Stop Violations</td>
<td>dbname: database_nametabid: table_id</td>
</tr>
<tr>
<td>STPR</td>
<td>Set Pdqpriority</td>
<td>flags: priority_level17</td>
</tr>
<tr>
<td>STRL</td>
<td>Set Role</td>
<td>dbname: database_nameobjname: role_name</td>
</tr>
<tr>
<td>STRS</td>
<td>Set Resident</td>
<td>dbname: database_nameobjname: fragment_list extra_1: fragment_information</td>
</tr>
<tr>
<td>STRT</td>
<td>Start Violations</td>
<td>dbname: database_nametabid: table_id extra_1: Vio_tid flags: Dia_tid</td>
</tr>
<tr>
<td>STSA</td>
<td>Set Session Authorization</td>
<td>dbname: database_namelogin: new_user_name</td>
</tr>
<tr>
<td>STSC</td>
<td>Set Statement Cache</td>
<td>objname: statement_name</td>
</tr>
<tr>
<td>STSN</td>
<td>Start New Session</td>
<td>none</td>
</tr>
<tr>
<td>STSV</td>
<td>Set Savepoint</td>
<td>dbname: database_name extra_1: transaction_id objname: savepoint_name</td>
</tr>
<tr>
<td>STTX</td>
<td>Set Transaction Mode</td>
<td>extra_1: operation20flags: mode_flags19 extra_2:</td>
</tr>
<tr>
<td>SVXD</td>
<td>Save External Directives</td>
<td>dbname: database_nameobjname: active&#x2F;inactive&#x2F;test objname: directive_text</td>
</tr>
<tr>
<td>TCTB</td>
<td>Truncate Table</td>
<td>dbname: database_nametabid: table_id objname: table_name</td>
</tr>
<tr>
<td>ULTB</td>
<td>Unlock Table</td>
<td>dbname: database_nametabid: table_id</td>
</tr>
<tr>
<td>UPAM</td>
<td>Update Audit Mask</td>
<td>login: user id</td>
</tr>
<tr>
<td>UPCK</td>
<td>Bring Chunk Online</td>
<td>extra_1: chunk_numberflags: mirror_status1</td>
</tr>
<tr>
<td>UPDM</td>
<td>Enable Disk Mirroring</td>
<td>extra_1: dbspace_number</td>
</tr>
<tr>
<td>UPRW</td>
<td>Update Current® Row</td>
<td>dbname: database_nametabid: table_id extra_1: old_part_number row_num: old_row_id14 flags: new_row_id extra_2: new_part_number</td>
</tr>
<tr>
<td>USSP</td>
<td>Update Statistics, SPL Routine</td>
<td>dbname: database_nametabid: proc_id</td>
</tr>
<tr>
<td>USTB</td>
<td>Update Statistics, Table</td>
<td>dbname: database_nametabid: table_id</td>
</tr>
</tbody></table>
 
      <!-- reward -->
      
    </div>
    

    <!-- copyright -->
    
    <div class="declare">
      <ul class="post-copyright">
        <li>
          <i class="ri-copyright-line"></i>
          <strong>Copyright： </strong>
          
          Copyright is owned by the author. For commercial reprints, please contact the author for authorization. For non-commercial reprints, please indicate the source.
          
        </li>
      </ul>
    </div>
    
    <footer class="article-footer">
       
<div class="share-btn">
      <span class="share-sns share-outer">
        <i class="ri-share-forward-line"></i>
        分享
      </span>
      <div class="share-wrap">
        <i class="arrow"></i>
        <div class="share-icons">
          
          <a class="weibo share-sns" href="javascript:;" data-type="weibo">
            <i class="ri-weibo-fill"></i>
          </a>
          <a class="weixin share-sns wxFab" href="javascript:;" data-type="weixin">
            <i class="ri-wechat-fill"></i>
          </a>
          <a class="qq share-sns" href="javascript:;" data-type="qq">
            <i class="ri-qq-fill"></i>
          </a>
          <a class="douban share-sns" href="javascript:;" data-type="douban">
            <i class="ri-douban-line"></i>
          </a>
          <!-- <a class="qzone share-sns" href="javascript:;" data-type="qzone">
            <i class="icon icon-qzone"></i>
          </a> -->
          
          <a class="facebook share-sns" href="javascript:;" data-type="facebook">
            <i class="ri-facebook-circle-fill"></i>
          </a>
          <a class="twitter share-sns" href="javascript:;" data-type="twitter">
            <i class="ri-twitter-fill"></i>
          </a>
          <a class="google share-sns" href="javascript:;" data-type="google">
            <i class="ri-google-fill"></i>
          </a>
        </div>
      </div>
</div>

<div class="wx-share-modal">
    <a class="modal-close" href="javascript:;"><i class="ri-close-circle-line"></i></a>
    <p>扫一扫，分享到微信</p>
    <div class="wx-qrcode">
      <img src="//api.qrserver.com/v1/create-qr-code/?size=150x150&data=http://example.com/2023/05/10/GBase8s%E5%A6%82%E4%BD%95%E9%85%8D%E7%BD%AE%E5%AE%A1%E8%AE%A1%E5%8A%9F%E8%83%BD/" alt="微信分享二维码">
    </div>
</div>

<div id="share-mask"></div>  
  <ul class="article-tag-list" itemprop="keywords"><li class="article-tag-list-item"><a class="article-tag-list-link" href="/tags/%E5%AE%A1%E8%AE%A1/" rel="tag">审计</a></li></ul>

    </footer>
  </div>

   
  <nav class="article-nav">
    
      <a href="/2023/05/10/GBase8s%E6%99%BA%E8%83%BD%E5%A4%A7%E5%AF%B9%E8%B1%A1%E7%A9%BA%E9%97%B4%E6%BB%A1%E5%9C%BA%E6%99%AF/" class="article-nav-link">
        <strong class="article-nav-caption">上一篇</strong>
        <div class="article-nav-title">
          
            GBase8s智能大对象空间满场景
          
        </div>
      </a>
    
    
      <a href="/2023/05/10/GBase8s%E7%9A%84Server%E5%92%8CCM%E7%9A%84%E6%97%A5%E5%BF%97%E6%8C%89%E5%A4%A9%E5%88%86%E7%89%87/" class="article-nav-link">
        <strong class="article-nav-caption">下一篇</strong>
        <div class="article-nav-title">GBase8s的Server和CM的日志按天分片</div>
      </a>
    
  </nav>

  
   
  
    
</article>

</section>
      <footer class="footer">
  <div class="outer">
    <ul>
      <li>
        Copyrights &copy;
        2023-2024
        <i class="ri-heart-fill heart_icon"></i> Wang Wei
      </li>
    </ul>
    <ul>
      <li>
        
      </li>
    </ul>
    <ul>
      <li>
        
        
        <span>
  <span><i class="ri-user-3-fill"></i>Visitors:<span id="busuanzi_value_site_uv"></span></span>
  <span class="division">|</span>
  <span><i class="ri-eye-fill"></i>Views:<span id="busuanzi_value_page_pv"></span></span>
</span>
        
      </li>
    </ul>
    <ul>
      
    </ul>
    <ul>
      
    </ul>
    <ul>
      <li>
        <!-- cnzz统计 -->
        
      </li>
    </ul>
  </div>
</footer>    
    </main>
    <div class="float_btns">
      <div class="totop" id="totop">
  <i class="ri-arrow-up-line"></i>
</div>

    </div>
    <aside class="sidebar on">
      <button class="navbar-toggle"></button>
<nav class="navbar">
  
  <div class="logo">
    <a href="/"><img src="/images/ww.ico" alt="朝花夕拾"></a>
  </div>
  
  <ul class="nav nav-main">
    
    <li class="nav-item">
      <a class="nav-item-link" href="/">主页</a>
    </li>
    
    <li class="nav-item">
      <a class="nav-item-link" href="/archives">归档</a>
    </li>
    
    <li class="nav-item">
      <a class="nav-item-link" href="/categories">分类</a>
    </li>
    
    <li class="nav-item">
      <a class="nav-item-link" href="/tags">标签</a>
    </li>
    
  </ul>
</nav>
<nav class="navbar navbar-bottom">
  <ul class="nav">
    <li class="nav-item">
      
      <a class="nav-item-link nav-item-search"  title="Search">
        <i class="ri-search-line"></i>
      </a>
      
      
    </li>
  </ul>
</nav>
<div class="search-form-wrap">
  <div class="local-search local-search-plugin">
  <input type="search" id="local-search-input" class="local-search-input" placeholder="Search...">
  <div id="local-search-result" class="local-search-result"></div>
</div>
</div>
    </aside>
    <div id="mask"></div>

<!-- #reward -->
<div id="reward">
  <span class="close"><i class="ri-close-line"></i></span>
  <p class="reward-p"><i class="ri-cup-line"></i>请我喝杯咖啡吧~</p>
  <div class="reward-box">
    
    <div class="reward-item">
      <img class="reward-img" src="/images/alipay.jpg">
      <span class="reward-type">支付宝</span>
    </div>
    
    
    <div class="reward-item">
      <img class="reward-img" src="/images/wechat.jpg">
      <span class="reward-type">微信</span>
    </div>
    
  </div>
</div>
    
<script src="/js/jquery-3.6.0.min.js"></script>
 
<script src="/js/lazyload.min.js"></script>

<!-- Tocbot -->
 
<script src="/js/tocbot.min.js"></script>

<script>
  tocbot.init({
    tocSelector: ".tocbot",
    contentSelector: ".article-entry",
    headingSelector: "h1, h2, h3, h4, h5, h6",
    hasInnerContainers: true,
    scrollSmooth: true,
    scrollContainer: "main",
    positionFixedSelector: ".tocbot",
    positionFixedClass: "is-position-fixed",
    fixedSidebarOffset: "auto",
  });
</script>

<script src="https://cdn.staticfile.org/jquery-modal/0.9.2/jquery.modal.min.js"></script>
<link
  rel="stylesheet"
  href="https://cdn.staticfile.org/jquery-modal/0.9.2/jquery.modal.min.css"
/>
<script src="https://cdn.staticfile.org/justifiedGallery/3.8.1/js/jquery.justifiedGallery.min.js"></script>

<script src="/dist/main.js"></script>

<!-- ImageViewer -->

<!-- MathJax -->

<!-- Katex -->

<!-- busuanzi  -->
 
<script src="/js/busuanzi-2.3.pure.min.js"></script>
 
<!-- ClickLove -->

<!-- ClickBoom1 -->

<!-- ClickBoom2 -->

<!-- CodeCopy -->
 
<link rel="stylesheet" href="/css/clipboard.css">
 <script src="https://cdn.staticfile.org/clipboard.js/2.0.10/clipboard.min.js"></script>
<script>
  function wait(callback, seconds) {
    var timelag = null;
    timelag = window.setTimeout(callback, seconds);
  }
  !function (e, t, a) {
    var initCopyCode = function(){
      var copyHtml = '';
      copyHtml += '<button class="btn-copy" data-clipboard-snippet="">';
      copyHtml += '<i class="ri-file-copy-2-line"></i><span>COPY</span>';
      copyHtml += '</button>';
      $(".highlight .code pre").before(copyHtml);
      $(".article pre code").before(copyHtml);
      var clipboard = new ClipboardJS('.btn-copy', {
        target: function(trigger) {
          return trigger.nextElementSibling;
        }
      });
      clipboard.on('success', function(e) {
        let $btn = $(e.trigger);
        $btn.addClass('copied');
        let $icon = $($btn.find('i'));
        $icon.removeClass('ri-file-copy-2-line');
        $icon.addClass('ri-checkbox-circle-line');
        let $span = $($btn.find('span'));
        $span[0].innerText = 'COPIED';
        
        wait(function () { // 等待两秒钟后恢复
          $icon.removeClass('ri-checkbox-circle-line');
          $icon.addClass('ri-file-copy-2-line');
          $span[0].innerText = 'COPY';
        }, 2000);
      });
      clipboard.on('error', function(e) {
        e.clearSelection();
        let $btn = $(e.trigger);
        $btn.addClass('copy-failed');
        let $icon = $($btn.find('i'));
        $icon.removeClass('ri-file-copy-2-line');
        $icon.addClass('ri-time-line');
        let $span = $($btn.find('span'));
        $span[0].innerText = 'COPY FAILED';
        
        wait(function () { // 等待两秒钟后恢复
          $icon.removeClass('ri-time-line');
          $icon.addClass('ri-file-copy-2-line');
          $span[0].innerText = 'COPY';
        }, 2000);
      });
    }
    initCopyCode();
  }(window, document);
</script>
 
<!-- CanvasBackground -->

<script>
  if (window.mermaid) {
    mermaid.initialize({ theme: "forest" });
  }
</script>


    
    

  </div>
</body>

</html>